![]() |
![]() |
![]() |
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
![]() |
![]() |
To access the contents, click the chapter and section titles.
Oracle Performance Tuning and Optimization
By setting goals for how you expect the system to perform, you can easily determine whether you are successful. You can also determine earlier in the design process whether you will be able to achieve those goals.
Design ConsiderationsThe first part of this chapter provided you with a good idea of how the OLTP system operates based on the data access patterns. Before you look at the design of the system, here is a review of a few of the concepts described in earlier chapters:
These factors contribute to determining the optimal data layout of the system. The physical layoutalong with SGA and shared pool tuningcreates an optimally configured server for the typical OLTP application. Of course, proper design of the application is just as important, but that topic is addressed in Part IV of this book, Tuning SQL. Physical Data LayoutThis section looks at how the data on the system should be configured on the physical disks. First, it looks at how to lay out the data on traditional disks; then it looks at disk arrays. I recommend using disk arrays if at all possible; the ease of use and performance benefits are worth the cost of the array. The main goal in designing the physical data layout is to isolate the sequential I/Os and to provide balanced I/Os across all the disks that are randomly accessed. Earlier in this chapter, you learned that the redo log files and the archive log files in an OLTP system are all accessed sequentially. You also know that the majority (if not all) of the data files are accessed in a random fashion. Many of the concepts presented here represent the best-case scenario. I realize that budgetary constraints do not permit everyone to buy the optimal number of disks for this configuration. Make the most of these guidelines. Remember that it is the number of disks that provide performance in an OLTP system; if you have the opportunity to buy one 4 gigabyte disk drive or two 2 gigabyte disk drives, the best performance comes from the two 2 gigabyte disk drives.
|
![]() |
Products | Contact Us | About Us | Privacy | Ad Info | Home
Use of this site is subject to certain Terms & Conditions, Copyright © 1996-2000 EarthWeb Inc. All rights reserved. Reproduction whole or in part in any form or medium without express written permission of EarthWeb is prohibited. |